package dao.provider;

import org.apache.ibatis.annotations.Param;
import pojo.Provider;

import java.util.List;

public interface ProviderMapper {
    public Provider getProviderByProCode(String proCode);

    public int getProviderCount(@Param("proName")String proName, @Param("proAddress")String proAddress);

    //根据条件查询用户列表
    public List<Provider> getProviderListByPage(@Param("proName")String proName,
                                                @Param("proAddress")String proAddress,
                                            @Param("currentPageNo")Integer currentPageNo,
                                            @Param("pageSize")Integer pageSize);

    List<Provider> getProviderList();

    int addProvider(Provider provider) throws Exception;

    Provider getProviderById(@Param("id") Integer id);

    int modifyProvider(Provider provider) throws Exception;

    //删除用户
    public int deleteProviderById(int id) throws Exception;

}
